package com.sky.task;

import com.sky.entity.Orders;
import com.sky.mapper.OrderMapper;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.scheduling.annotation.Scheduled;
import org.springframework.stereotype.Component;

import java.time.LocalDateTime;
import java.util.List;


@Component
@Slf4j
public class MyTask {
    @Autowired
    private OrderMapper orderMapper;
   // @Scheduled(cron = " * 0/1 * * * ? * ")//每1分钟执行一次
    public void executeTask(){
        log.info("定时处理超时订单:{}", LocalDateTime.now());
        LocalDateTime time = LocalDateTime.now().plusMinutes(-15);
        //select *from ordes where status=0 and order_time < date_sub(now(),interval 10 minute)
        List<Orders> ordersList = orderMapper.getBystatusAndOrderTimeLT(Orders.PENDING_PAYMENT, time);

        if (ordersList!=null && ordersList.size()>0){

            for (Orders orders : ordersList) {
                //update orders set status=3 where id=?
                orders.setStatus(Orders.CANCELLED);
                orders.setCancelReason("超时未支付");
                orders.setCancelTime(LocalDateTime.now());
                orderMapper.update(orders);
            }
        }
    }
}
